SAS Merchandise Data Integration fails to load data in a non-partitioned table. During the load, SAS Merchandise Data Integration does not wait for the delete process to finish before attempting to upload the data. When this issue occurs, the following errors are generated in the log:

Before loading data into a non-partitioned table, run the following procedures on the table:

• maxdata.p_db_make_tablespace
• maxdata.p_db_make_table_partition

For additional information about these jobs please refer to the documentation for SAS Merchandise Data Integration.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Merchandise Financial Planning	Microsoft Windows Server 2008 R2	6.1.3 M6	6.5_M1	9.2 TS2M2	9.4 TS1M0
		Microsoft Windows Server 2008 for x64	6.1.3 M6	6.5_M1	9.2 TS2M2	9.4 TS1M0
		64-bit Enabled AIX	6.1.3 M6	6.5_M1	9.2 TS2M2	9.4 TS1M0
		64-bit Enabled Solaris	6.1.3 M6	6.5_M1	9.2 TS2M2	9.4 TS1M0
		Microsoft Windows Server 2003 for x64	6.1.3 M6		9.2 TS2M2
		Microsoft Windows Server 2003 Standard Edition	6.1.3 M6		9.2 TS2M2
		Microsoft Windows Server 2003 Enterprise Edition	6.1.3 M6		9.2 TS2M2
		Microsoft Windows Server 2003 Datacenter Edition	6.1.3 M6		9.2 TS2M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

SAS® Merchandise Data Integration does not wait for the delete process to finish before attempting to upload data in non-partitioned fact tables. This causes the load to fail and produces errors in the log.

Type:	Problem Note
Priority:	medium

Date Modified:	2014-09-24 11:35:18
Date Created:	2014-09-18 13:06:19